create external table jms_ods.yl_oms_order_third_ext(
ID bigint ,
ORDER_ID bigint comment '订单id' ,
TYPE int comment '1.菜鸟',
INPUT_TIME timestamp comment '录入时间',
IS_DELETE int comment '是否删除,1未删除，2已删除',
POST_SITE_CODE string comment '驿站编码',
POST_SITE_NAME string comment '驿站名称',
STATION_CODE string comment '驿站码',
POST_SITE_ADDRESS string comment '驿站地址',
STATION_UNIQUE_NUMBER string comment '驿站唯一标识'
)comment '订单拓展表'
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
 stored as parquet
    LOCATION
   '/dw/hive/jms_ods.db/external/yl_oms_order_third_ext'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)
